Downloading Data Dictionaries

Once the metadata is scanned and stored in the repository, you can instantly view and export data dictionary at the environment and table levels.

A data dictionary at environment level includes definitions of all the tables and columns available in the environment. Whereas, a data dictionary at table level includes the definitions of the table and its columns.

Environment Level

To download data dictionaries at environment level, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to see its details.
  3. Click Options.
    The available options appear.
  4. Click Data Dictionary > Download.

    5. The Data Dictionary-Download Options page appears.

  5. Use the following options:
    Default Template Download
    Use this option to download the data dictionary in a default template. The default template includes technical and business properties of tables and columns.
    Advanced Template Download
    Use this option to download the data dictionary in an advanced template. You can customize an advanced template to include additional information, such as Indexes Summary, Extended Properties for Tables, Valid Values, and Extended Properties for columns.
  6. Click .

    7. Data dictionary is downloaded in the XLSX format.

Table Level

To download data dictionaries at table level, follow these steps:

  1. In the Data Catalog pane, click a table.
  2. Click Options.
    The available options appear.
  3. Click Data Dictionary > Download.

    4. The data dictionary of the selected table is downloaded in the XLSX format.

You can also view data dictionary report at system level and update data dictionary at environment level.